Data Profiling Report

Dataset statistics

Number of variables	17
Number of observations	21103
Missing cells	566
Missing cells (%)	0.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	6.2 MiB
Average record size in memory	308.2 B

Variable types

Categorical	4
Numeric	13

Alerts

`ACType` is highly overall correlated with `AC_role` and 1 other fields	High correlation
`AC_role` is highly overall correlated with `ACType`	High correlation
`airGroundVector_groundSpeed` is highly overall correlated with `calculated_time`	High correlation
`calculated_time` is highly overall correlated with `airGroundVector_groundSpeed` and 2 other fields	High correlation
`distapt` is highly overall correlated with `calculated_time` and 2 other fields	High correlation
`dwpt` is highly overall correlated with `temp`	High correlation
`emitterCat` is highly overall correlated with `ACType`	High correlation
`h3_id` is highly overall correlated with `distapt`	High correlation
`hrstart` is highly overall correlated with `rhum` and 1 other fields	High correlation
`rhum` is highly overall correlated with `hrstart` and 2 other fields	High correlation
`temp` is highly overall correlated with `dwpt` and 2 other fields	High correlation
`ttland` is highly overall correlated with `calculated_time` and 1 other fields	High correlation
`wspd` is highly overall correlated with `rhum`	High correlation
`AC_role` is highly imbalanced (89.3%)	Imbalance
`dwpt` has 234 (1.1%) missing values	Missing
`rhum` has 234 (1.1%) missing values	Missing
`ttland` has unique values	Unique
`hrstart` has 1153 (5.5%) zeros	Zeros
`wdir` has 873 (4.1%) zeros	Zeros
`wspd` has 839 (4.0%) zeros	Zeros

Reproduction

Analysis started	2024-10-09 19:06:24.690179
Analysis finished	2024-10-09 19:07:15.629421
Duration	50.94 seconds
Software version	ydata-profiling vv4.9.0
Download configuration	config.json

ACType
Categorical

HIGH CORRELATION

Distinct	36
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	1.3 MiB

E175	3575
A321-200	2631
B737-800	2156
B737-8	1760
B737-700	1558
Other values (31)	9423

Length

Max length	11
Median length	8
Mean length	7.1028764
Min length	4

Characters and Unicode

Total characters	149892
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	A321-200
2nd row	E175
3rd row	A321-200
4th row	A320-200
5th row	B737-700

Common Values

Value	Count	Frequency (%)
E175	3575	16.9%
A321-200	2631	12.5%
B737-800	2156	10.2%
B737-8	1760	8.3%
B737-700	1558	7.4%
A320-200	1547	7.3%
B737-900	1381	6.5%
B777-300	879	4.2%
B787-9	735	3.5%
B737-9	542	2.6%
Other values (26)	4339	20.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
e175	3575	16.6%
a321-200	2631	12.2%
b737-800	2156	10.0%
b737-8	1760	8.2%
b737-700	1558	7.2%
a320-200	1547	7.2%
b737-900	1381	6.4%
b777-300	879	4.1%
b787-9	735	3.4%
b737-9	542	2.5%
Other values (27)	4734	22.0%

Most occurring characters

Value	Count	Frequency (%)
0	31008	20.7%
7	27154	18.1%
-	17703	11.8%
3	15421	10.3%
B	10539	7.0%
2	9740	6.5%
1	7884	5.3%
8	6134	4.1%
A	6072	4.1%
5	4646	3.1%
Other values (16)	13591	9.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	149892	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	31008	20.7%
7	27154	18.1%
-	17703	11.8%
3	15421	10.3%
B	10539	7.0%
2	9740	6.5%
1	7884	5.3%
8	6134	4.1%
A	6072	4.1%
5	4646	3.1%
Other values (16)	13591	9.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	149892	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	31008	20.7%
7	27154	18.1%
-	17703	11.8%
3	15421	10.3%
B	10539	7.0%
2	9740	6.5%
1	7884	5.3%
8	6134	4.1%
A	6072	4.1%
5	4646	3.1%
Other values (16)	13591	9.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	149892	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	31008	20.7%
7	27154	18.1%
-	17703	11.8%
3	15421	10.3%
B	10539	7.0%
2	9740	6.5%
1	7884	5.3%
8	6134	4.1%
A	6072	4.1%
5	4646	3.1%
Other values (16)	13591	9.1%

AC_role
Categorical

HIGH CORRELATION IMBALANCE

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

PAX	20515
Not Found	395
CAR	168
VIP	25

Length

Max length	9
Median length	3
Mean length	3.1123063
Min length	3

Characters and Unicode

Total characters	65679
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	PAX
2nd row	PAX
3rd row	PAX
4th row	PAX
5th row	PAX

Common Values

Value	Count	Frequency (%)
PAX	20515	97.2%
Not Found	395	1.9%
CAR	168	0.8%
VIP	25	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
pax	20515	95.4%
not	395	1.8%
found	395	1.8%
car	168	0.8%
vip	25	0.1%

Most occurring characters

Value	Count	Frequency (%)
A	20683	31.5%
P	20540	31.3%
X	20515	31.2%
o	790	1.2%
N	395	0.6%
t	395	0.6%
	395	0.6%
F	395	0.6%
u	395	0.6%
n	395	0.6%
Other values (5)	781	1.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	65679	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	20683	31.5%
P	20540	31.3%
X	20515	31.2%
o	790	1.2%
N	395	0.6%
t	395	0.6%
	395	0.6%
F	395	0.6%
u	395	0.6%
n	395	0.6%
Other values (5)	781	1.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	65679	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	20683	31.5%
P	20540	31.3%
X	20515	31.2%
o	790	1.2%
N	395	0.6%
t	395	0.6%
	395	0.6%
F	395	0.6%
u	395	0.6%
n	395	0.6%
Other values (5)	781	1.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	65679	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	20683	31.5%
P	20540	31.3%
X	20515	31.2%
o	790	1.2%
N	395	0.6%
t	395	0.6%
	395	0.6%
F	395	0.6%
u	395	0.6%
n	395	0.6%
Other values (5)	781	1.2%

ttland
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	21103
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	39.963119

Minimum	30.204979
Maximum	106.74826
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	165.0 KiB

Quantile statistics

Minimum	30.204979
5-th percentile	33.232191
Q1	35.806494
median	39.832966
Q3	43.098615
95-th percentile	48.105207
Maximum	106.74826
Range	76.543286
Interquartile range (IQR)	7.2921209

Descriptive statistics

Standard deviation	4.8528809
Coefficient of variation (CV)	0.12143399
Kurtosis	3.3570873
Mean	39.963119
Median Absolute Deviation (MAD)	3.6808573
Skewness	0.80403349
Sum	843341.7
Variance	23.550453
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
39.58688199	1	< 0.1%
38.15249364	1	< 0.1%
32.63368179	1	< 0.1%
37.65359716	1	< 0.1%
39.16423423	1	< 0.1%
32.1277138	1	< 0.1%
33.60764008	1	< 0.1%
33.29120458	1	< 0.1%
33.14425843	1	< 0.1%
33.75548267	1	< 0.1%
Other values (21093)	21093	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
30.20497925	1	< 0.1%
30.35569807	1	< 0.1%
30.7282061	1	< 0.1%
30.73048397	1	< 0.1%
30.74439908	1	< 0.1%
30.84378548	1	< 0.1%
30.9591821	1	< 0.1%
30.97033041	1	< 0.1%
30.97110544	1	< 0.1%
31.00340979	1	< 0.1%

Value	Count	Frequency (%)
106.7482648	1	< 0.1%
89.47997004	1	< 0.1%
86.78711363	1	< 0.1%
79.52256125	1	< 0.1%
76.65375682	1	< 0.1%
75.31273657	1	< 0.1%
73.4691458	1	< 0.1%
73.13808881	1	< 0.1%
68.87363018	1	< 0.1%
67.08390361	1	< 0.1%

hrstart
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	24
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.18604

Minimum	0
Maximum	23
Zeros	1153
Zeros (%)	5.5%
Negative	0
Negative (%)	0.0%
Memory size	165.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	4
median	14
Q3	19
95-th percentile	23
Maximum	23
Range	23
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	7.848888
Coefficient of variation (CV)	0.64408849
Kurtosis	-1.4826981
Mean	12.18604
Median Absolute Deviation (MAD)	7
Skewness	-0.24444364
Sum	257162
Variance	61.605043
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
3	1481	7.0%
23	1365	6.5%
2	1362	6.5%
14	1312	6.2%
15	1304	6.2%
4	1227	5.8%
18	1169	5.5%
0	1153	5.5%
19	1143	5.4%
17	1140	5.4%
Other values (14)	8447	40.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1153	5.5%
1	1127	5.3%
2	1362	6.5%
3	1481	7.0%
4	1227	5.8%
5	843	4.0%
6	483	2.3%
7	150	0.7%
8	101	0.5%
9	24	0.1%

Value	Count	Frequency (%)
23	1365	6.5%
22	1114	5.3%
21	1122	5.3%
20	1109	5.3%
19	1143	5.4%
18	1169	5.5%
17	1140	5.4%
16	998	4.7%
15	1304	6.2%
14	1312	6.2%

distapt
Real number (ℝ)

HIGH CORRELATION

Distinct	20974
Distinct (%)	99.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	214.06982

Minimum	190.63084
Maximum	239.6557
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	165.0 KiB

Quantile statistics

Minimum	190.63084
5-th percentile	199.11331
Q1	202.05281
median	214.58231
Q3	226.4519
95-th percentile	235.61538
Maximum	239.6557
Range	49.024861
Interquartile range (IQR)	24.399089

Descriptive statistics

Standard deviation	12.641882
Coefficient of variation (CV)	0.059054948
Kurtosis	-1.1717278
Mean	214.06982
Median Absolute Deviation (MAD)	12.170367
Skewness	0.36591698
Sum	4517515.5
Variance	159.81719
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
205.6164846	3	< 0.1%
199.677132	3	< 0.1%
201.8056157	2	< 0.1%
224.2541233	2	< 0.1%
226.8969343	2	< 0.1%
206.3944691	2	< 0.1%
199.4760571	2	< 0.1%
205.6773785	2	< 0.1%
199.3338501	2	< 0.1%
206.2497057	2	< 0.1%
Other values (20964)	21081	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
190.6308418	1	< 0.1%
191.0247307	1	< 0.1%
191.1164989	1	< 0.1%
191.2247616	1	< 0.1%
191.5548098	1	< 0.1%
191.5673339	1	< 0.1%
191.6335508	1	< 0.1%
191.7748041	1	< 0.1%
191.8835506	1	< 0.1%
192.0324036	1	< 0.1%

Value	Count	Frequency (%)
239.655703	1	< 0.1%
239.6400802	1	< 0.1%
239.6316843	1	< 0.1%
239.6306094	1	< 0.1%
239.6288354	1	< 0.1%
239.6262386	1	< 0.1%
239.6126801	1	< 0.1%
239.6067415	1	< 0.1%
239.6027732	1	< 0.1%
239.598043	1	< 0.1%

flightLevel
Real number (ℝ)

Distinct	963
Distinct (%)	4.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	331.14812

Minimum	18.75
Maximum	470
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	165.0 KiB

Quantile statistics

Minimum	18.75
5-th percentile	209.75
Q1	320
median	350
Q3	370
95-th percentile	400
Maximum	470
Range	451.25
Interquartile range (IQR)	50

Descriptive statistics

Standard deviation	73.185342
Coefficient of variation (CV)	0.22100486
Kurtosis	8.4123612
Mean	331.14812
Median Absolute Deviation (MAD)	20
Skewness	-2.6858723
Sum	6988218.8
Variance	5356.0943
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
350	2741	13.0%
370	2178	10.3%
360	1794	8.5%
380	1375	6.5%
340	1287	6.1%
390	1033	4.9%
400	576	2.7%
330	511	2.4%
320	457	2.2%
410	373	1.8%
Other values (953)	8778	41.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
18.75	1	< 0.1%
19	1	< 0.1%
19.25	5	< 0.1%
19.5	11	0.1%
19.75	17	0.1%
20	28	0.1%
20.25	31	0.1%
20.5	57	0.3%
20.75	76	0.4%
21	86	0.4%

Value	Count	Frequency (%)
470	10	< 0.1%
450.5	1	< 0.1%
450	30	0.1%
449.75	7	< 0.1%
449.5	1	< 0.1%
430.25	2	< 0.1%
430	31	0.1%
429.75	5	< 0.1%
428.5	1	< 0.1%
420	2	< 0.1%

emitterCat
Real number (ℝ)

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	84
Missing (%)	0.4%
Infinite	0
Infinite (%)	0.0%
Mean	3.3640516

Minimum	0
Maximum	5
Zeros	5
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	165.0 KiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	3
median	3
Q3	3
95-th percentile	5
Maximum	5
Range	5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.83676458
Coefficient of variation (CV)	0.24873714
Kurtosis	0.25190669
Mean	3.3640516
Median Absolute Deviation (MAD)	0
Skewness	1.1629604
Sum	70709
Variance	0.70017496
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
3	15698	74.4%
5	4013	19.0%
2	780	3.7%
4	489	2.3%
1	34	0.2%
0	5	< 0.1%
(Missing)	84	0.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5	< 0.1%
1	34	0.2%
2	780	3.7%
3	15698	74.4%
4	489	2.3%
5	4013	19.0%

Value	Count	Frequency (%)
5	4013	19.0%
4	489	2.3%
3	15698	74.4%
2	780	3.7%
1	34	0.2%
0	5	< 0.1%

airGroundVector_groundSpeed
Real number (ℝ)

HIGH CORRELATION

Distinct	1123
Distinct (%)	5.3%
Missing	7
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	440.2875

Minimum	61.962891
Maximum	571.06934
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	165.0 KiB

Quantile statistics

Minimum	61.962891
5-th percentile	373.0957
Q1	429.3457
median	449.34082
Q3	469.99512
95-th percentile	505.37109
Maximum	571.06934
Range	509.10645
Interquartile range (IQR)	40.649414

Descriptive statistics

Standard deviation	65.598824
Coefficient of variation (CV)	0.14899088
Kurtosis	13.243234
Mean	440.2875
Median Absolute Deviation (MAD)	20.43457
Skewness	-3.3010907
Sum	9288305.2
Variance	4303.2057
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
457.4707031	110	0.5%
439.6728516	110	0.5%
448.9013672	98	0.5%
449.5605469	96	0.5%
446.7041016	92	0.4%
461.6455078	89	0.4%
437.6953125	87	0.4%
442.0898438	86	0.4%
442.96875	86	0.4%
439.8925781	86	0.4%
Other values (1113)	20156	95.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
61.96289062	1	< 0.1%
65.91796875	1	< 0.1%
69.87304688	1	< 0.1%
73.828125	1	< 0.1%
74.92675781	1	< 0.1%
76.90429688	2	< 0.1%
77.78320312	1	< 0.1%
82.83691406	1	< 0.1%
83.93554688	1	< 0.1%
88.98925781	2	< 0.1%

Value	Count	Frequency (%)
571.0693359	1	< 0.1%
570.8496094	1	< 0.1%
568.8720703	1	< 0.1%
567.7734375	1	< 0.1%
567.3339844	1	< 0.1%
565.1367188	1	< 0.1%
564.2578125	1	< 0.1%
560.9619141	1	< 0.1%
560.0830078	1	< 0.1%
559.8632812	1	< 0.1%

calculated_time
Real number (ℝ)

HIGH CORRELATION

Distinct	21096
Distinct (%)	100.0%
Missing	7
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	30.866479

Minimum	20.939816
Maximum	199.39124
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	165.0 KiB

Quantile statistics

Minimum	20.939816
5-th percentile	24.788596
Q1	26.520102
median	28.220305
Q3	30.95077
95-th percentile	35.927872
Maximum	199.39124
Range	178.45142
Interquartile range (IQR)	4.4306681

Descriptive statistics

Standard deviation	12.279866
Coefficient of variation (CV)	0.39783825
Kurtosis	30.759957
Mean	30.866479
Median Absolute Deviation (MAD)	2.0636169
Skewness	5.2600058
Sum	651159.24
Variance	150.79511
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
35.85938342	1	< 0.1%
26.08497353	1	< 0.1%
27.34765578	1	< 0.1%
28.99179504	1	< 0.1%
25.68684526	1	< 0.1%
26.33164334	1	< 0.1%
26.83582353	1	< 0.1%
25.96067705	1	< 0.1%
27.51063706	1	< 0.1%
29.45045796	1	< 0.1%
Other values (21086)	21086	99.9%
(Missing)	7	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
20.9398163	1	< 0.1%
21.3158781	1	< 0.1%
21.4781371	1	< 0.1%
21.4879273	1	< 0.1%
21.5374657	1	< 0.1%
21.55341601	1	< 0.1%
21.6702647	1	< 0.1%
21.67337249	1	< 0.1%
21.67754009	1	< 0.1%
21.71644292	1	< 0.1%

Value	Count	Frequency (%)
199.3912361	1	< 0.1%
187.4957132	1	< 0.1%
175.8955064	1	< 0.1%
166.4799851	1	< 0.1%
164.9032959	1	< 0.1%
160.6294636	1	< 0.1%
159.8172501	1	< 0.1%
158.7940672	1	< 0.1%
149.1560004	1	< 0.1%
147.1894824	1	< 0.1%

h3_id
Categorical

HIGH CORRELATION

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

8229affffffffff	9248
8229b7fffffffff	7005
82298ffffffffff	1929
82291ffffffffff	1086
822987fffffffff	1028
Other values (3)	807

Length

Max length	15
Median length	15
Mean length	15
Min length	15

Characters and Unicode

Total characters	316545
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	8229b7fffffffff
2nd row	8229affffffffff
3rd row	8229b7fffffffff
4th row	8229affffffffff
5th row	8229b7fffffffff

Common Values

Value	Count	Frequency (%)
8229affffffffff	9248	43.8%
8229b7fffffffff	7005	33.2%
82298ffffffffff	1929	9.1%
82291ffffffffff	1086	5.1%
822987fffffffff	1028	4.9%
822917fffffffff	684	3.2%
82485ffffffffff	67	0.3%
822937fffffffff	56	0.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
8229affffffffff	9248	43.8%
8229b7fffffffff	7005	33.2%
82298ffffffffff	1929	9.1%
82291ffffffffff	1086	5.1%
822987fffffffff	1028	4.9%
822917fffffffff	684	3.2%
82485ffffffffff	67	0.3%
822937fffffffff	56	0.3%

Most occurring characters

Value	Count	Frequency (%)
f	202257	63.9%
2	42139	13.3%
8	24127	7.6%
9	21036	6.6%
a	9248	2.9%
7	8773	2.8%
b	7005	2.2%
1	1770	0.6%
4	67	< 0.1%
5	67	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	316545	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
f	202257	63.9%
2	42139	13.3%
8	24127	7.6%
9	21036	6.6%
a	9248	2.9%
7	8773	2.8%
b	7005	2.2%
1	1770	0.6%
4	67	< 0.1%
5	67	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	316545	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
f	202257	63.9%
2	42139	13.3%
8	24127	7.6%
9	21036	6.6%
a	9248	2.9%
7	8773	2.8%
b	7005	2.2%
1	1770	0.6%
4	67	< 0.1%
5	67	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	316545	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
f	202257	63.9%
2	42139	13.3%
8	24127	7.6%
9	21036	6.6%
a	9248	2.9%
7	8773	2.8%
b	7005	2.2%
1	1770	0.6%
4	67	< 0.1%
5	67	< 0.1%

temp
Real number (ℝ)

HIGH CORRELATION

Distinct	82
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20.917874

Minimum	15.6
Maximum	28.3
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	165.0 KiB

Quantile statistics

Minimum	15.6
5-th percentile	17.2
Q1	19
median	21
Q3	22.8
95-th percentile	25
Maximum	28.3
Range	12.7
Interquartile range (IQR)	3.8

Descriptive statistics

Standard deviation	2.3098092
Coefficient of variation (CV)	0.11042275
Kurtosis	-0.41081986
Mean	20.917874
Median Absolute Deviation (MAD)	1.8
Skewness	0.20104769
Sum	441429.9
Variance	5.3352184
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19.4	1575	7.5%
20	1405	6.7%
18.9	1366	6.5%
21.1	1349	6.4%
21.7	1285	6.1%
22.2	1158	5.5%
20.6	1104	5.2%
22.8	1094	5.2%
23.3	940	4.5%
17.8	840	4.0%
Other values (72)	8987	42.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
15.6	65	0.3%
16	15	0.1%
16.1	156	0.7%
16.7	345	1.6%
17	155	0.7%
17.2	555	2.6%
17.3	4	< 0.1%
17.8	840	4.0%
17.9	1	< 0.1%
18	397	1.9%

Value	Count	Frequency (%)
28.3	17	0.1%
28	21	0.1%
27.8	21	0.1%
27.2	64	0.3%
27	44	0.2%
26.7	35	0.2%
26.1	170	0.8%
26	49	0.2%
25.6	174	0.8%
25.2	23	0.1%

dwpt
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	59
Distinct (%)	0.3%
Missing	234
Missing (%)	1.1%
Infinite	0
Infinite (%)	0.0%
Mean	16.480799

Minimum	12.3
Maximum	19.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	165.0 KiB

Quantile statistics

Minimum	12.3
5-th percentile	14.7
Q1	15.7
median	16.5
Q3	17.2
95-th percentile	18.3
Maximum	19.5
Range	7.2
Interquartile range (IQR)	1.5

Descriptive statistics

Standard deviation	1.1278213
Coefficient of variation (CV)	0.068432438
Kurtosis	-0.17632743
Mean	16.480799
Median Absolute Deviation (MAD)	0.8
Skewness	0.025538247
Sum	343937.8
Variance	1.2719808
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16.1	2002	9.5%
15.6	1518	7.2%
16.6	1329	6.3%
17.2	1259	6.0%
16.7	1227	5.8%
17.3	975	4.6%
16	870	4.1%
15.7	774	3.7%
15	746	3.5%
17.8	678	3.2%
Other values (49)	9491	45.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12.3	21	0.1%
12.9	18	0.1%
13.1	4	< 0.1%
13.3	23	0.1%
13.5	27	0.1%
13.7	29	0.1%
13.9	96	0.5%
14	110	0.5%
14.1	61	0.3%
14.3	162	0.8%

Value	Count	Frequency (%)
19.5	17	0.1%
19.4	9	< 0.1%
19.3	36	0.2%
19.2	60	0.3%
19	155	0.7%
18.9	172	0.8%
18.8	194	0.9%
18.7	17	0.1%
18.6	22	0.1%
18.4	266	1.3%

rhum
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	41
Distinct (%)	0.2%
Missing	234
Missing (%)	1.1%
Infinite	0
Infinite (%)	0.0%
Mean	76.439456

Minimum	51
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	165.0 KiB

Quantile statistics

Minimum	51
5-th percentile	62
Q1	70
median	76
Q3	84
95-th percentile	93
Maximum	100
Range	49
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	9.0705411
Coefficient of variation (CV)	0.11866308
Kurtosis	-0.65145645
Mean	76.439456
Median Absolute Deviation (MAD)	7
Skewness	0.16336521
Sum	1595215
Variance	82.274715
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
71	1960	9.3%
73	1811	8.6%
84	1683	8.0%
81	1587	7.5%
87	1577	7.5%
76	1505	7.1%
90	1156	5.5%
78	1043	4.9%
69	1041	4.9%
66	995	4.7%
Other values (31)	6511	30.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
51	17	0.1%
55	20	0.1%
56	48	0.2%
57	20	0.1%
58	80	0.4%
59	98	0.5%
60	389	1.8%
61	171	0.8%
62	398	1.9%
63	71	0.3%

Value	Count	Frequency (%)
100	32	0.2%
97	215	1.0%
96	181	0.9%
93	628	3.0%
91	77	0.4%
90	1156	5.5%
89	4	< 0.1%
87	1577	7.5%
86	89	0.4%
85	16	0.1%

wdir
Real number (ℝ)

ZEROS

Distinct	84
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	238.6918

Minimum	0
Maximum	360
Zeros	873
Zeros (%)	4.1%
Negative	0
Negative (%)	0.0%
Memory size	165.0 KiB

Quantile statistics

Minimum	0
5-th percentile	80
Q1	247
median	258
Q3	260
95-th percentile	280
Maximum	360
Range	360
Interquartile range (IQR)	13

Descriptive statistics

Standard deviation	62.114756
Coefficient of variation (CV)	0.26022996
Kurtosis	7.4910722
Mean	238.6918
Median Absolute Deviation (MAD)	8
Skewness	-2.7914796
Sum	5037113
Variance	3858.2429
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
260	5068	24.0%
250	3733	17.7%
270	3371	16.0%
240	1873	8.9%
0	873	4.1%
230	643	3.0%
280	569	2.7%
256	331	1.6%
258	302	1.4%
259	296	1.4%
Other values (74)	4044	19.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	873	4.1%
10	1	< 0.1%
15	20	0.1%
20	17	0.1%
30	5	< 0.1%
40	24	0.1%
60	2	< 0.1%
62	6	< 0.1%
70	4	< 0.1%
75	15	0.1%

Value	Count	Frequency (%)
360	36	0.2%
350	36	0.2%
340	20	0.1%
337	4	< 0.1%
332	8	< 0.1%
330	36	0.2%
320	157	0.7%
310	28	0.1%
300	135	0.6%
290	144	0.7%

wspd
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	39
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.61777

Minimum	0
Maximum	30
Zeros	839
Zeros (%)	4.0%
Negative	0
Negative (%)	0.0%
Memory size	165.0 KiB

Quantile statistics

Minimum	0
5-th percentile	5.4
Q1	9.4
median	14.8
Q3	20.5
95-th percentile	24.1
Maximum	30
Range	30
Interquartile range (IQR)	11.1

Descriptive statistics

Standard deviation	6.5418091
Coefficient of variation (CV)	0.44752443
Kurtosis	-0.6430663
Mean	14.61777
Median Absolute Deviation (MAD)	5.4
Skewness	-0.20225532
Sum	308478.8
Variance	42.795267
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=39)

Value	Count	Frequency (%)
13	1828	8.7%
20.5	1733	8.2%
18.4	1663	7.9%
14.8	1520	7.2%
16.6	1397	6.6%
7.6	1380	6.5%
22.3	1238	5.9%
11.2	1232	5.8%
9.4	1226	5.8%
5.4	1056	5.0%
Other values (29)	6830	32.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	839	4.0%
1.8	3	< 0.1%
3.7	28	0.1%
5.4	1056	5.0%
5.5	132	0.6%
6	385	1.8%
7	250	1.2%
7.4	251	1.2%
7.6	1380	6.5%
9	221	1.0%

Value	Count	Frequency (%)
30	48	0.2%
29.5	23	0.1%
28	84	0.4%
27.8	42	0.2%
27.7	88	0.4%
26	85	0.4%
25.9	364	1.7%
24.1	805	3.8%
24	252	1.2%
22.3	1238	5.9%

pres
Real number (ℝ)

Distinct	102
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1013.3384

Minimum	1007.6
Maximum	1018.3
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	165.0 KiB

Quantile statistics

Minimum	1007.6
5-th percentile	1010.1
Q1	1012
median	1013.4
Q3	1014.7
95-th percentile	1016.9
Maximum	1018.3
Range	10.7
Interquartile range (IQR)	2.7

Descriptive statistics

Standard deviation	1.9863116
Coefficient of variation (CV)	0.0019601662
Kurtosis	-0.31735568
Mean	1013.3384
Median Absolute Deviation (MAD)	1.4
Skewness	0.0063491509
Sum	21384480
Variance	3.945434
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1014	1359	6.4%
1013	1235	5.9%
1012	672	3.2%
1015	671	3.2%
1011	577	2.7%
1014.1	492	2.3%
1013.3	487	2.3%
1013.6	467	2.2%
1013.7	452	2.1%
1012.1	381	1.8%
Other values (92)	14310	67.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1007.6	15	0.1%
1007.7	42	0.2%
1008	39	0.2%
1008.2	7	< 0.1%
1008.4	28	0.1%
1008.6	16	0.1%
1008.7	13	0.1%
1008.8	33	0.2%
1008.9	3	< 0.1%
1009	40	0.2%

Value	Count	Frequency (%)
1018.3	15	0.1%
1018.2	38	0.2%
1018	100	0.5%
1017.9	39	0.2%
1017.8	35	0.2%
1017.7	46	0.2%
1017.6	114	0.5%
1017.5	82	0.4%
1017.4	71	0.3%
1017.3	14	0.1%

coco
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.2 MiB

2.0	14356
3.0	3062
5.0	2951
1.0	407
4.0	327

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	63309
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	5.0
2nd row	5.0
3rd row	5.0
4th row	5.0
5th row	5.0

Common Values

Value	Count	Frequency (%)
2.0	14356	68.0%
3.0	3062	14.5%
5.0	2951	14.0%
1.0	407	1.9%
4.0	327	1.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2.0	14356	68.0%
3.0	3062	14.5%
5.0	2951	14.0%
1.0	407	1.9%
4.0	327	1.5%

Most occurring characters

Value	Count	Frequency (%)
.	21103	33.3%
0	21103	33.3%
2	14356	22.7%
3	3062	4.8%
5	2951	4.7%
1	407	0.6%
4	327	0.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	63309	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
.	21103	33.3%
0	21103	33.3%
2	14356	22.7%
3	3062	4.8%
5	2951	4.7%
1	407	0.6%
4	327	0.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	63309	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
.	21103	33.3%
0	21103	33.3%
2	14356	22.7%
3	3062	4.8%
5	2951	4.7%
1	407	0.6%
4	327	0.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	63309	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
.	21103	33.3%
0	21103	33.3%
2	14356	22.7%
3	3062	4.8%
5	2951	4.7%
1	407	0.6%
4	327	0.5%

Auto

Heatmap
Table

	ACType	AC_role	airGroundVector_groundSpeed	calculated_time	coco	distapt	dwpt	emitterCat	flightLevel	h3_id	hrstart	pres	rhum	temp	ttland	wdir	wspd
ACType	1.000	0.693	0.264	0.093	0.046	0.304	0.025	0.772	0.324	0.291	0.196	0.023	0.069	0.070	0.182	0.041	0.076
AC_role	0.693	1.000	0.113	0.081	0.018	0.055	0.023	0.311	0.269	0.087	0.198	0.021	0.059	0.062	0.064	0.047	0.061
airGroundVector_groundSpeed	0.264	0.113	1.000	-0.809	0.048	-0.130	-0.050	0.477	0.342	0.360	-0.048	-0.060	0.071	-0.083	-0.236	0.016	-0.027
calculated_time	0.093	0.081	-0.809	1.000	0.008	0.639	0.050	-0.463	-0.355	0.312	0.092	0.039	-0.092	0.101	0.657	0.009	0.057
coco	0.046	0.018	0.048	0.008	1.000	0.032	0.136	0.016	0.026	0.035	0.220	0.147	0.315	0.256	0.056	0.167	0.172
distapt	0.304	0.055	-0.130	0.639	0.032	1.000	0.032	-0.139	-0.066	0.572	0.112	0.006	-0.082	0.088	0.811	0.031	0.074
dwpt	0.025	0.023	-0.050	0.050	0.136	0.032	1.000	-0.021	-0.022	0.028	0.231	-0.031	-0.052	0.515	0.015	-0.065	-0.014
emitterCat	0.772	0.311	0.477	-0.463	0.016	-0.139	-0.021	1.000	0.444	0.129	0.022	-0.013	-0.030	0.016	-0.160	0.011	0.036
flightLevel	0.324	0.269	0.342	-0.355	0.026	-0.066	-0.022	0.444	1.000	0.355	0.032	0.013	-0.040	0.027	-0.176	0.001	0.042
h3_id	0.291	0.087	0.360	0.312	0.035	0.572	0.028	0.129	0.355	1.000	0.178	0.028	0.067	0.068	0.379	0.037	0.050
hrstart	0.196	0.198	-0.048	0.092	0.220	0.112	0.231	0.022	0.032	0.178	1.000	0.172	-0.524	0.561	0.063	0.112	0.274
pres	0.023	0.021	-0.060	0.039	0.147	0.006	-0.031	-0.013	0.013	0.028	0.172	1.000	-0.142	0.118	-0.034	-0.075	-0.128
rhum	0.069	0.059	0.071	-0.092	0.315	-0.082	-0.052	-0.030	-0.040	0.067	-0.524	-0.142	1.000	-0.866	0.003	-0.123	-0.547
temp	0.070	0.062	-0.083	0.101	0.256	0.088	0.515	0.016	0.027	0.068	0.561	0.118	-0.866	1.000	0.006	0.060	0.455
ttland	0.182	0.064	-0.236	0.657	0.056	0.811	0.015	-0.160	-0.176	0.379	0.063	-0.034	0.003	0.006	1.000	0.026	0.053
wdir	0.041	0.047	0.016	0.009	0.167	0.031	-0.065	0.011	0.001	0.037	0.112	-0.075	-0.123	0.060	0.026	1.000	0.393
wspd	0.076	0.061	-0.027	0.057	0.172	0.074	-0.014	0.036	0.042	0.050	0.274	-0.128	-0.547	0.455	0.053	0.393	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	ACType	AC_role	ttland	distapt	flightLevel	emitterCat	airGroundVector_groundSpeed	calculated_time	h3_id	temp	dwpt	rhum	wdir	wspd	pres	coco
0	A321-200	PAX	39.586882	206.102875	339.75	3.0	419.897461	29.450458	8229b7fffffffff	17.8	15.1	84.0	270.0	18.4	1012.1	5.0
1	E175	PAX	43.902720	219.248186	206.25	3.0	392.211914	33.540264	8229affffffffff	17.8	15.1	84.0	270.0	18.4	1012.1	5.0
2	A321-200	PAX	37.227303	205.968685	320.00	3.0	427.587891	28.901944	8229b7fffffffff	17.8	15.1	84.0	270.0	18.4	1012.1	5.0
3	A320-200	PAX	41.766306	219.155811	229.50	3.0	445.385742	29.523506	8229affffffffff	17.8	15.1	84.0	270.0	18.4	1012.1	5.0
4	B737-700	PAX	39.449535	201.120239	360.00	3.0	406.494141	29.686072	8229b7fffffffff	17.8	15.1	84.0	270.0	18.4	1012.1	5.0
5	Not Found	Not Found	44.847852	227.006608	409.75	2.0	469.775391	28.993423	8229affffffffff	17.8	15.1	84.0	270.0	18.4	1012.1	5.0
6	B737-800	PAX	51.367967	228.036874	350.00	3.0	483.178711	28.317085	8229affffffffff	17.8	15.1	84.0	270.0	18.4	1012.1	5.0
7	E175	PAX	35.934729	198.479053	276.50	3.0	439.672852	27.085464	8229b7fffffffff	17.8	15.1	84.0	270.0	18.4	1012.1	5.0
8	A319-100	PAX	46.709177	226.808320	370.25	3.0	457.031250	29.775862	8229affffffffff	17.8	15.1	84.0	270.0	18.4	1012.1	5.0
9	E175	PAX	47.058034	235.793836	330.00	3.0	459.887695	30.763228	82298ffffffffff	17.8	15.1	84.0	270.0	18.4	1012.1	5.0

	ACType	AC_role	ttland	hrstart	distapt	flightLevel	emitterCat	airGroundVector_groundSpeed	calculated_time	h3_id	temp	dwpt	rhum	wdir	wspd	pres	coco
21093	E175	PAX	43.018234	22	233.320779	370.00	3.0	454.394531	30.808572	8229affffffffff	22.1	15.9	68.0	258.0	22.2	1012.6	2.0
21094	B737-800	PAX	33.681040	22	199.827281	356.50	3.0	451.538086	26.552881	8229b7fffffffff	22.1	15.9	68.0	258.0	22.2	1012.6	2.0
21095	A340-300	PAX	38.343261	23	209.320012	360.00	5.0	421.655273	29.785470	822987fffffffff	21.6	15.7	69.0	261.0	25.9	1012.4	2.0
21096	A321-200	PAX	38.588756	23	208.223071	360.00	3.0	442.309570	28.245792	822987fffffffff	21.6	15.7	69.0	261.0	25.9	1012.4	2.0
21097	B787-9	PAX	37.842898	23	208.812302	399.75	5.0	457.910156	27.360691	822987fffffffff	21.6	15.7	69.0	261.0	25.9	1012.4	2.0
21098	B777-300	PAX	38.734179	23	210.723916	370.00	5.0	526.025391	24.035788	82291ffffffffff	21.6	15.7	69.0	261.0	25.9	1012.4	2.0
21099	E175	PAX	38.059619	23	220.036093	350.00	3.0	502.734375	26.260718	8229affffffffff	21.6	15.7	69.0	261.0	25.9	1012.4	2.0
21100	A319-100	PAX	35.744987	23	199.650028	360.25	3.0	450.219727	26.607012	8229b7fffffffff	21.6	15.7	69.0	261.0	25.9	1012.4	2.0
21101	B737-700	PAX	34.387204	23	199.309256	385.00	3.0	438.354492	27.280559	8229b7fffffffff	21.6	15.7	69.0	261.0	25.9	1012.4	2.0
21102	A380-800	PAX	35.945765	23	207.840993	400.00	5.0	478.784180	26.046098	822987fffffffff	21.6	15.7	69.0	261.0	25.9	1012.4	2.0

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample